package com.hzncc.flowable_diboot.excel.model;

import com.alibaba.excel.annotation.ExcelProperty;
import com.diboot.file.excel.BaseExcelModel;
import lombok.Data;

import java.time.LocalDateTime;
import java.util.Date;

@Data
public class CustomerOldCrmImportModel extends BaseExcelModel {

    @ExcelProperty(value = "SAP编号" )
    private String sapNo;

    @ExcelProperty(value = "客户名称" )
    private String customerName;

    @ExcelProperty(value = "统一信用代码" )
    private String unifiedCreditCode;

    @ExcelProperty(value = "省份" )
    private String provinces;

    @ExcelProperty(value = "市" )
    private String city;

    @ExcelProperty(value = "地址" )
    private String address;

    @ExcelProperty(value = "机床厂类型" )
    private String machineToolPlantType;

    @ExcelProperty(value = "机床厂规模" )
    private String scaleOfMachineToolPlant;

    @ExcelProperty(value = "机床厂市场定位" )
    private String machineToolFactoryMarketPositioning;

    @ExcelProperty(value = "负责人" )
    private String personInCharge;

    @ExcelProperty(value = "销售员" )
    private String salesperson;

    @ExcelProperty(value = "订单等级（上年度配套华中数控系统数量）")
    private String orderLevel;

    @ExcelProperty(value = "销售模式" )
    private String salesModel;

    @ExcelProperty(value = "客户跟进状态" )
    private String customerFollowUpStatus;

    @ExcelProperty(value = "主配系统" )
    private String mainSystem;

    @ExcelProperty(value = "对标竞争对手" )
    private String competitors;

    @ExcelProperty(value = "主要对标竞争对手描述" )
    private String descriptionOfMainCompetitors;

    @ExcelProperty(value = "可配套核心因素" )
    private String supportingCoreFactors;

    @ExcelProperty(value = "客户主要人员解读" )
    private String keyCustomerPersonnelInterpretation;

    @ExcelProperty(value = "客户主要经营描述" )
    private String customerMainBusinessDescription;

    @ExcelProperty(value = "客户销售与服务描述" )
    private String customerSalesAndServiceDescription;

    @ExcelProperty(value = "客户合作方向分析" )
    private String customerCooperationDirectionAnalysis;

    @ExcelProperty(value = "销售人员查询" )
    private String salesStaffQuery;

    /*
        国际客户
     */

    /**
     * 国家
     */
    @ExcelProperty(value = "国家" )
    private String country;

    @ExcelProperty(value = "产品类型" )
    private String internationalClientProductType;

    @ExcelProperty(value = "区域划分" )
    private String areaDivision;

    @ExcelProperty(value = "询盘质量" )
    private String inquiryQuality;

    @ExcelProperty(value = "询盘日期" )
    private String inquiryDate;

    @ExcelProperty(value = "公司" )
    private String internationalCustomerCompany;

    @ExcelProperty(value = "国家/地区")
    private String internationalCustomerArea;

    @ExcelProperty(value = "客户来源渠道")
    private String internationalCustomerSource;

    @ExcelProperty(value = "客户跟进状态")
    private String internationalFollowStatus;

    @ExcelProperty(value = "网址")
    private String webUrl;

    @ExcelProperty(value = "客户类型")
    private String internationalCustomerType;

    @ExcelProperty(value = "创建人")
    private String createBy;

    @ExcelProperty(value = "大区")
    private String majorArea;

    @ExcelProperty(value = "公司业务描述")
    private String businessDescription;

    @ExcelProperty(value = "修改时间")
    private LocalDateTime updateTime;

    @ExcelProperty(value = "电话号码")
    private String phoneNumber;

    @ExcelProperty(value = "邮箱")
    private String email;

    @ExcelProperty(value = "邮政编码")
    private String postCode;

    @ExcelProperty(value = "备注")
    private String remark;

    @ExcelProperty(value = "产品名称")
    private String productName;

    @ExcelProperty(value = "城市")
    private String internationalCustomerCity;

    @ExcelProperty(value = "协作人")
    private String collaborator;
}
